Measurement

Entity Definition

Logical Name : Measurement
Physical Name : CO_MSRMT

A named quantity that is used to assess the frequency, magnitude and volume of business activity. Measurements may be derived through formulas or simply represent operational facts.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
MeasurementID (PK) Token ID for a Measurement instance. ID_MSRMT Identity integer
MeasurementName Business name assigned to a Measurement. NM_MSRMT DescriptionShort varchar(255)
MeasurementTypeCode (FK) Indicates the category of measurement represented by this MeasurementType instance. Valid values include: VOLUME = number of units or a count FREQUENCY = number of occurences in a time period MAGNITUDE = relative size of each unit CD_MSRMT_TYP Code varchar(20) MeasurementType(LU_MSRMT_TYP)
UnitOfMeasureCode (FK) The code used to specify the units in which a value is being expressed, or manner in which a measurement has been taken. This code relates to the UCC data element 355. CD_UOM Code varchar(20) UnitOfMeasure(CO_UOM)
ISOCurrencyCode (FK) Currency code designated by ISO to identify national currency CD_CNY_ISO_4217 ISO_4217_CurrencyCode_char(3) char(3) ISO4217-CurrencyType(LU_CNY_ISO_4217)

Relationships

Parent Entity Verb Phrase Child Entity
ISO4217-CurrencyType is monetary unit of Measurement
UnitOfMeasure defines counting units for Measurement
MeasurementType classifies Measurement
Measurement value is constrained by MeasurementRange

No Logical Views for Measurement